Unique Strict Registry entry
Specify whether unique checks should be performed on a column that has been defined as unique on the server (in the table schema itself or using a Unique Index Registry entry). By default all unique columns are checked for uniqueness. With this entry it is possible to override the uniqueness check.
By default, all columns configured as unique in the table schema (by the developer) or using the Unique Index Registry entry are checked for uniqueness whenever a value is entered in the associated field and focus leaves the field. Setting Unique Strict to false
disables the uniqueness check, allowing the record to be saved with duplicate values in the unique columns.
The Unique Override Registry entry performs a similar function to the Unique Strict Registry entry, allowing users / groups to save a record that violates uniqueness. A major difference is that users with the Unique Override permission receive a warning message that the column or columns are normally required to be unique, and must confirm that they wish to save the record with duplicate value(s).
Note: The warning message that displays for users with the Unique Override permission is defined in a Unique Registry entry.
When the Unique Strict Registry entry is specified for a column, affected users are able to save duplicate records without receiving a warning message.
However, if a user has the Unique Override permission for a column and the Unique Strict Registry entry is specified for the same column, that user will still receive the warning message and will need to confirm that they wish to save the record with duplicate value(s).
Usage
This Registry entry can be assigned to users and groups:
Key | User | User | Group | Group | Group | Group |
---|---|---|---|---|---|---|
Key 1 | User
|
User
|
Group
|
Group
|
Group
|
Group
|
Key 2 | user | user | group | group | Default
|
Default
|
Key 3 | Table
|
Table
|
Table
|
Table
|
Table
|
Table
|
Key 4 | table | Default
|
table | Default
|
table | Default
|
Key 5 | Unique Strict
|
|||||
Key 6 | column | |||||
Value | boolean |
User
|
user | Table
|
table | Unique Strict
|
column | boolean |
User
|
user | Table
|
Default
|
Unique Strict
|
column | boolean |
Group
|
group | Table
|
table | Unique Strict
|
column | boolean |
Group
|
group | Table
|
Default
|
Unique Strict
|
column | boolean |
Group
|
Default
|
Table
|
table | Unique Strict
|
column | boolean |
Group
|
Default
|
Table
|
Default
|
Unique Strict
|
column | boolean |
where:
column |
the back-end name of the column set to be unique in the table schema (by the developer) or by using the Unique Registry entry. |
boolean |
is either Note:
In the absence of this entry, a setting of |
Example
This entry specifies that the InfLoanNumber field may contain duplicate values:
Key | Setting |
---|---|
Key 1 | Group
|
Key 2 | Default
|
Key 3 | Table
|
Key 4 | eloans
|
Key 5 | Unique Strict
|
Key 6 | InfLoanNumber
|
Value | false
|